package com.yutian.endecryption.mock.mapper;

import com.yutian.endecryption.mock.pojo.SubGroupDetail;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * 考生分组明细mapper
 *
 * @author zhang peng yang ming
 * @create 2017-08-01 11:48
 */
public interface SubGroupDetailMapper {

    @Select("SELECT * FROM vt_subgroup_detail_info WHERE sfzmhm=#{sfzmhm}")
    SubGroupDetail retrieveSubGroupDetail (String sfzmhm);

    @Update("UPDATE vt_subgroup_detail_info SET sfzmhm=#{sfzmhm}, xm=#{xm}, dlr=#{dlr}, xh=#{xh} WHERE id=#{id}")
    int updateSubGroupDetail (SubGroupDetail detail);

    @Insert("INSERT INTO vt_subgroup_detail_info (sfzmhm, xm, dlr, xh) VALUES (#{sfzmhm}, #{xm}, #{dlr}, #{xh});")
    int createSubGroupDetail (SubGroupDetail detail);
}
